package com.lkei.dao;

import com.lkei.entity.TeacherStudentNotice;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 *教师发布的通知DAO
 * @author 周贵有
 */
@Repository
public interface TeacherMessageNoticeDAO {

    /**
     * 新增（教师-学生）通知
     * @param teacherStudentNotice
     */
    void addTeacherNotice(TeacherStudentNotice teacherStudentNotice);

    /**
     * 根据教职工号查询通知
     * @param teacherID
     */
    List<TeacherStudentNotice> findNotice(Integer teacherID);

    /**
     * 根据消息编号查出通知详情
     * @param MessageID
     * @return
     */
    String findNoticeByMessageID(Integer MessageID);

    /**
     * 根据学号查询通知
     * @param StudentID
     */
    List<TeacherStudentNotice> findNoticeByStudentID(Long StudentID);

    void DeleteMessage(Integer MessageID);

    /**
     * 删掉中间表的关系数据
     * @param MessageID
     */
    void DeleteRelationship(Integer MessageID);
}
